SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 531507 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 531507 [ RunTime:0.004269s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (894988,628296,481328,223525,203201,595928,829886,778585,327059,836416,900519,254160,163434,130184,484939,378863,261768,141125,873962,17381,444290,774199,509067,438450,730735,940690,855918,599813,575639,643681,475274,535772,684626,597134,1763,838543,352655,485145,875257,183413,347772,20043,528108,1033465,959746,625232,155296,956405,111220,645879,675184,161790,819138,711909,162898,849368,457692,723914,280653,260973) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 531507 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 531507 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]