SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406421 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406421 [ RunTime:0.001771s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (667713,808904,41478,142253,641564,403986,1014312,332356,873971,742017,922170,147542,425076,726568,985599,266474,953861,921392,478683,893844,275279,183061,541790,910155,759145,632743,748291,275885,578071,603428,723659,522224,414274,676742,802720,460685,565416,51263,815433,308020,210931,153877,599033,939061,657276,209429,501307,968795,557897,480333,596787,1029634,433474,750614,608699,986829,471209,840514,1044031,315121) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406421 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406421 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]