SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405898 LIMIT 1 [ RunTime:0.000372s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405898 [ RunTime:0.003971s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (509728,888997,758467,848018,8218,51133,712724,884276,875194,733944,149574,227297,379189,639810,25605,475851,258781,248354,310588,465765,883989,642120,218479,757562,373598,764529,296493,130939,792379,903239,611690,743763,415447,82626,400271,225468,972816,1047818,172466,356877,177655,956459,149821,976191,245940,943453,169502,812932,505840,567356,641164,781973,89607,431281,485902,289441,863906,712876,784246,1032422) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405898 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405898 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000765s ]