SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201218 LIMIT 1 [ RunTime:0.000528s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201218 [ RunTime:0.001869s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014637,965560,731021,615578,922827,287355,950039,394472,27984,62041,104497,633582,850695,176528,599000,891140,118941,611335,779122,36776,965706,125735,188412,764503,14770,173928,189893,400336,427303,1022092,537365,738831,1042458,878282,789849,620579,975906,477239,237660,100980,886974,695579,79236,42098,929190,579794,415221,92600,77612,507033,739465,701330,552713,640123,936470,210496,667334,336212,904103,946595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201218 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201218 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]