SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019380 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019380 [ RunTime:0.001679s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (828191,981496,109916,901929,465563,597367,857004,717012,643255,561760,333947,513069,176528,665827,1006753,327063,223567,395417,16181,736537,862830,115061,188537,134208,844116,570091,526562,913232,1007148,977097,331029,582460,546973,220604,130312,629235,1006513,445410,1040604,526812,460799,674516,1022235,356138,253363,860779,978592,357304,423790,836452,343991,396346,79617,499998,275319,779415,251750,820584,348699,560645) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019380 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019380 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]