SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006574s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 50408 LIMIT 1 [ RunTime:0.000500s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 50408 [ RunTime:0.007186s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (95427,637668,252204,935974,69217,340441,441892,281317,869034,170850,11884,950137,667844,225300,641932,886926,1041733,656573,290721,958127,134373,608952,347778,829086,1033633,979732,7844,494305,767905,583795,382637,657025,912735,1016372,305385,364980,837344,199513,911447,13682,539294,751704,345771,618978,553101,751961,45435,502607,436979,882998,349567,67063,792345,660834,272291,259277,808060,574890,843531,241976) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004155s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 50408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 50408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000933s ]