SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001336s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 922948 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 922948 [ RunTime:0.005327s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (818952,63191,541841,812034,844914,701563,150664,350872,192724,219991,626410,338229,574434,582341,1202,745455,588652,58910,50401,157103,11274,549768,424176,228815,642528,472754,774245,106666,599950,648189,886460,550174,460923,749168,904355,645219,398106,145290,427413,275636,402181,174585,1013197,171471,77245,171984,911560,139233,354654,565916,98771,363462,297425,472266,222126,870825,1035938,810681,892867,873189) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 922948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000671s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 922948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]