SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447241 LIMIT 1 [ RunTime:0.000438s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447241 [ RunTime:0.002784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (460064,761817,630150,405899,777855,567234,1045448,951358,310367,823104,452074,655806,62317,1000611,996621,976922,316448,198359,629813,739120,830132,139029,185587,934346,322054,272605,827472,981930,562375,188943,1009680,595759,37774,404053,813153,750529,624140,844359,264970,363915,398615,156965,491361,182111,595233,779548,186694,960575,147316,306818,659006,635909,60152,972179,462641,886835,933509,863961,298353,97674) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002507s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447241 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447241 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]