SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 445371 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 445371 [ RunTime:0.002237s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (412372,132238,660959,165002,514175,62199,327597,499441,774944,745060,207861,287677,949639,623849,532821,68580,369317,203662,690302,436796,63124,984000,179732,708356,938818,773774,956765,754052,605564,616454,817970,386101,90101,751979,854349,183155,504459,250716,415742,365921,175372,19441,240290,639298,148324,823091,553493,581696,942779,577976,164949,639680,128516,285958,813501,461335,17265,139561,752215,752101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 445371 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000440s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 445371 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]