SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001282s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 299776 LIMIT 1 [ RunTime:0.002547s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 299776 [ RunTime:0.003392s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (49946,231060,31030,427712,383333,315153,771124,552846,634545,80926,596191,454525,358697,1000245,865151,810083,662604,20614,680323,429389,109781,811882,334553,295729,52775,779897,85910,558890,113504,177774,198136,945380,95184,665922,225578,87452,81305,565898,284567,372263,1020473,778443,605152,297577,901595,1030813,18863,590765,457463,958203,959708,31385,301898,292429,496306,424469,989623,233804,352700,304758) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 299776 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 299776 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]