SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 528571 LIMIT 1 [ RunTime:0.001776s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 528571 [ RunTime:0.002474s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1028932,200809,976346,449393,688506,161608,667555,221781,976255,497108,118375,140874,558298,932279,323682,281911,240302,546383,221000,519916,888450,966797,285431,377870,838427,682484,913234,562165,1012857,714854,46293,572724,712096,659947,876187,522321,682959,1031946,190689,373599,839572,863356,349854,148975,235873,210542,194116,392795,999668,964618,54689,746305,585701,1592,273119,731534,236654,700521,69216,357920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.031751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 528571 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000597s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 528571 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.005224s ]