SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001490s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267112 LIMIT 1 [ RunTime:0.000687s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267112 [ RunTime:0.002278s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810856,964133,252437,444603,653725,675968,401212,936066,1043514,53889,250165,497633,999439,730875,3570,552316,563954,201338,249667,652506,819145,1032573,1026697,476454,512577,653629,840275,551856,53698,914913,629604,132724,169025,1048672,309083,955717,532793,232590,319939,655990,505600,410204,617100,653519,471274,863696,1030522,877564,803710,1023369,641153,741059,210978,667171,798811,75265,337679,190488,36095,210637) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001056s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267112 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267112 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000476s ]