SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501331 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501331 [ RunTime:0.001700s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (238364,266832,779830,518586,137373,607534,503457,930295,432233,136394,440385,303140,543625,343304,162117,214765,257666,590860,700900,282805,527985,789582,839701,98885,698405,805863,921908,146725,390494,989575,326259,686323,590529,790925,854657,466887,686901,749631,148228,484347,394701,1023438,371006,774406,73911,594474,523007,818840,257542,795070,781233,298096,781394,313647,621829,82153,428409,92343,281525,424135) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501331 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501331 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001471s ]