SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002514s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198220 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198220 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748112,464325,280414,122011,672098,38920,9802,627174,196002,867419,241525,693121,497654,903465,392425,11509,462537,592112,818812,452189,114894,530537,445549,753633,93951,688980,222121,1045434,643649,721403,607681,433278,430603,154506,429026,696940,273749,580822,94128,320473,290304,898125,482843,359603,863722,210061,215828,323121,194672,990021,924874,456616,289639,559587,570070,397424,706245,312782,835703,312101) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198220 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198220 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]