SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490531 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490531 [ RunTime:0.005110s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (203619,955063,36991,242078,932947,750671,899704,803267,144741,328969,26633,356920,812700,426979,505737,111269,358162,6592,403954,276150,1032548,855243,947268,602274,745241,871952,506555,792712,242705,432660,856118,500652,704503,178171,574070,86285,760511,445343,75352,836490,904125,883056,464517,801577,963610,533289,316658,983671,682869,374256,942131,373406,787011,796035,305122,224137,386474,795400,509489,31426) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002790s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490531 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490531 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]