SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001212s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 291383 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 291383 [ RunTime:0.003119s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820429,352087,950205,661690,859968,580417,654741,553949,371612,734749,811402,446068,415527,491294,686354,555936,699401,172136,369715,949498,783247,288687,186104,515699,956685,317589,675700,171334,979330,519947,141907,129158,465844,460849,414246,251318,352724,89604,112096,843958,62072,447497,428521,136017,309174,844733,217330,1022650,503213,38288,125719,57158,898089,482203,614984,549089,1042026,344613,594195,413635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 291383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 291383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000676s ]