SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023551 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023551 [ RunTime:0.001750s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1023742,224518,150027,582013,556575,933492,824671,745498,625026,632086,808277,788619,676665,175750,698526,606534,1015353,878556,522938,188472,244284,857028,89915,660828,680614,442536,915418,847449,303529,29708,441769,302673,146685,171459,625292,386963,772949,627561,538501,970161,14657,623613,177802,399335,77708,5001,238185,130297,643312,794594,238770,587078,207234,680344,377007,126385,505285,432030,250762,609524) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000614s ]