SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005523 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005523 [ RunTime:0.001475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (711098,659142,630493,197115,580066,899628,487886,607060,495939,45040,537165,754977,975198,200671,803752,230943,828002,917127,381275,574644,653840,160860,835301,146447,853784,214227,629028,1005080,548920,994715,877037,754949,175253,608808,391468,45266,675426,848928,1015285,111413,668655,403857,85596,263646,387196,507945,913210,648757,331242,634565,536028,1047309,83679,6621,146741,511968,586192,721427,252729,910154) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001743s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005523 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005523 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]