SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014381 LIMIT 1 [ RunTime:0.000623s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014381 [ RunTime:0.003203s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008335,751445,702128,802351,805513,939614,797134,216484,535784,155566,355869,295129,467025,178683,203498,350091,85527,815492,397455,328577,838618,202513,979321,42819,640210,378194,13437,218933,38911,672641,657298,378047,217703,853272,453146,802598,634617,784231,506240,682954,868153,798148,718803,598189,321470,518112,502854,978087,479613,231580,822667,691120,462621,197994,228072,465628,469763,415458,973548,261562) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014381 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014381 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000438s ]