SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026836 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026836 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (332529,329614,519480,991030,50697,615125,464257,129102,391852,560855,461070,440321,590695,970118,62534,559638,699984,115548,434339,937827,441080,469484,978188,590528,76959,973429,440120,779819,409995,154424,564179,417271,817741,941226,963153,483181,250194,979716,173487,399526,650242,180187,946499,20708,210577,740595,54890,732015,850305,14515,85014,745706,617936,858045,808971,564107,632167,284012,510091,1031604) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001003s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026836 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000465s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026836 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]