SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 488320 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 488320 [ RunTime:0.001887s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (197034,128951,202477,748959,1046456,414586,403702,182033,604757,409649,910776,298497,178063,494092,41857,869648,413837,515742,447973,989328,776421,453102,471741,840994,292803,756870,839403,580512,808055,228551,840012,597531,434942,404787,739247,731221,557682,592684,640788,527991,1031320,853604,667760,849480,295354,918930,832145,9188,548702,994973,826369,81587,547430,496122,634053,290907,988798,856017,449890,743696) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000945s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 488320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 488320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]