SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 202008 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 202008 [ RunTime:0.001580s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (311427,1031716,234347,148702,696254,927750,821452,318822,305605,535820,80968,998489,712911,501319,125495,360414,951698,336306,895836,15867,522945,619382,846617,411204,833866,194658,173200,511805,561732,111843,303515,319880,695798,462856,528845,331646,424845,529125,760514,135040,686249,177636,989414,575669,796274,327422,46872,956164,881449,468525,511372,801488,784979,69889,47011,889187,493801,788696,1046890,816915) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 202008 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 202008 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]