SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001097s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003300 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003300 [ RunTime:0.002220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28671,554353,345173,312361,1019074,1006837,679843,914972,350885,498303,42179,676946,910502,538697,75824,1031681,265309,185885,100396,172164,967846,302071,928542,701727,1005693,43831,649781,1012626,968528,779863,754076,222111,364445,312260,996890,717053,537712,861405,607413,19451,788829,591588,100064,761266,1046647,272720,180469,523218,206377,107717,212925,327832,561692,470764,182010,858531,363047,313245,705088,998109) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001562s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]