SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523308 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523308 [ RunTime:0.002398s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (291726,395301,1011495,639343,684767,60507,471445,284128,333928,940791,587708,980818,578489,204700,20197,128437,764220,719399,142787,506631,16108,237528,267176,702557,156530,620209,209679,623697,679348,349353,194211,673528,49931,303531,307844,469886,830188,850477,178758,256020,705747,308783,689719,758115,693409,825433,840473,450465,86198,997610,929301,3902,802897,410982,345577,269689,866786,1039499,560751,307210) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000976s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523308 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523308 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000563s ]